██ ██ ██ ██ ██████ ██ ██████ ██ ██ ███████ ██████ ██ ██
██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██
████ ██ ██ ██ ███ ██ ██ ██ ██ ██ █████ ██████ ████
██ ██ ██ ██ ██ ██ ██ ▄▄ ██ ██ ██ ██ ██ ██ ██
██ ██████ ██████ ██ ██████ ██████ ███████ ██ ██ ██
▀▀
Cards - Execution started 24/12/2023 20:07 UTC
By Guilherme Ruiz
By Guilherme Ruiz
Table of Contents ¶
- 1 Data aquisition
- 2 Check changes
- 3 Data visualization
- 3.1 Full data
- 3.2 Card types
- 3.3 Monsters
- 3.4 Spell & Trap
- 3.5 Effect type
- 3.6 Archseries
- 3.7 Artworks
- 3.8 Errata
- 3.9 TCG & OCG status
- 4 Extras
- 5 Epilogue
Data aquisition¶
Fetch online data¶
Downloading monsters
0%| | 0/8 [00:00<?, ?attribute/s]
Output()
Output()
Output()
Output()
Output()
Output()
Output()
Output()
8308 results
Downloading SpellsThe history saving thread hit an unexpected error (OperationalError('attempt to write a readonly database')).History will not be written to the database.
Output()
2515 results Downloading Traps
Output()
1888 results
Downloading tokens
Output()
210 results Downloading counters
Output()
15 results Downloading all errata
0%| | 0/3 [00:00<?, ?initial/s]
Output()
Output()
Output()
5039 results
Merge data¶
Data merged
Check changes¶
Load previous data¶
No cards files
Generate changelog¶
Skipped
Save data¶
Data saved
Data visualization¶
Full data¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Full data available to download here
Card types¶
Total number of card types: 3
Monsters¶
Attributes¶
Total number of attributes: 7
| Name | Password | Archseries | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Attribute | ||||||||||||||||||
| Loading... (need help?) |
Primary types¶
Total number of primary types: 7
| Name | Password | Archseries | Attribute | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Primary type | ||||||||||||||||||
| Loading... (need help?) |
Has effect discrimination¶
| Has effect | Effect | No Effect |
|---|---|---|
| Primary type | ||
| Loading... (need help?) |
Obs: Normal monster can have effect if it is pendulum
Is pendulum discrimination¶
| Is Pendulum | Pendulum | Not Pendulum |
|---|---|---|
| Primary type | ||
| Loading... (need help?) |
By attribute¶
| Attribute | DARK | DIVINE | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|---|
| Primary type | |||||||
| Loading... (need help?) |
Secondary types¶
Total number of secondary types: 6
| Name | Password | Archseries | Attribute | Primary type | Monster type | Effect type | DEF | Pendulum Scale | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Secondary type | ||||||||||||||||
| Loading... (need help?) |
By attribute¶
| Attribute | DARK | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|
| Secondary type | ||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | All |
|---|---|---|---|---|---|---|---|
| Primary type | |||||||
| Loading... (need help?) |
Monster types¶
Total number of monster types: 26
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Monster type | ||||||||||||||||||
| Loading... (need help?) |
By Attribute¶
| Attribute | DARK | DIVINE | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|---|
| Monster type | |||||||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster | nan |
|---|---|---|---|---|---|---|---|---|
| Monster type | ||||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | nan |
|---|---|---|---|---|---|---|---|
| Monster type | |||||||
| Loading... (need help?) |
ATK¶
Total number of ATK values: 83
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ATK | ||||||||||||||||||
| Loading... (need help?) |
DEF¶
Total number of DEF values: 78
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DEF | ||||||||||||||||||
| Loading... (need help?) |
Level/Rank¶
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Level/Rank | ||||||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Level/Rank | ||||||||
| Loading... (need help?) | ||||||||
DEF statistics¶
| DEF | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Level/Rank | ||||||||
| Loading... (need help?) | ||||||||
Pendulum scale¶
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pendulum Scale | ||||||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
DEF statistics¶
| DEF | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
Level/Rank statistics¶
| Level/Rank | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
Link¶
| Name | Password | Archseries | Attribute | Monster type | Effect type | Link Arrows | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link | |||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Link | ||||||||
| Loading... (need help?) | ||||||||
Link Arrows¶
By combination¶
Total number of link arrow combinations: 63
| Name | Password | Archseries | Attribute | Monster type | Effect type | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link Arrows | ||||||||||||
| Loading... (need help?) |
By unique¶
| Name | Password | Archseries | Attribute | Monster type | Effect type | Link | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link Arrows | |||||||||||||
| Loading... (need help?) |
By link¶
| Link | 1 | 2 | 3 | 4 | 5 | 6 |
|---|---|---|---|---|---|---|
| Link Arrows | ||||||
| Loading... (need help?) |
Spell & Trap¶
Properties¶
Total number of properties: 9
| Name | Password | Archseries | Effect type | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|
| Property | |||||||||
| Loading... (need help?) |
Effect type¶
Total number of effect types: 16
| Name | Password | Card type | Property | Archseries | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Effect type | ||||||||||||||||||||||
| Loading... (need help?) |
Card type discrimination¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Effect type | |||
| Loading... (need help?) |
Archseries¶
Total number of Archseries: 751
| Name | Password | Card type | Property | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card | All |
|---|---|---|---|---|
| Archseries | ||||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster | All |
|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | All |
|---|---|---|---|---|---|---|---|
| Archseries | |||||||
| Loading... (need help?) |
By monster type¶
| Monster type | Aqua | Beast | Beast-Warrior | Creator God | Cyberse | Dinosaur | Divine-Beast | Dragon | Fairy | Fiend | Fish | Illusion | Insect | Machine | Plant | Psychic | Pyro | Reptile | Rock | Sea Serpent | Spellcaster | Thunder | Warrior | Winged Beast | Wyrm | Zombie | All |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | |||||||||||||||||||||||||||
| Loading... (need help?) |
By property¶
| Property | Continuous Spell Card | Continuous Trap Card | Counter Trap Card | Equip Spell Card | Field Spell Card | Normal Spell Card | Normal Trap Card | Quick-Play Spell Card | Ritual Spell Card | All |
|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||||
| Loading... (need help?) |
Artworks¶
Total number of cards with edited or alternate artworks: 675
| Name | Password | TCG status | OCG status | Artwork | |
|---|---|---|---|---|---|
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Artwork | |||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster |
|---|---|---|---|---|---|---|---|
| Artwork | |||||||
| Loading... (need help?) |
More granularity is unnecessary
Errata¶
Total number of cards with errata: 4870
| Name | Password | TCG status | OCG status | Errata | |
|---|---|---|---|---|---|
| Loading... (need help?) |
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Errata | ||||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Errata | |||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster |
|---|---|---|---|---|---|---|---|
| Errata | |||||||
| Loading... (need help?) |
More granularity is unnecessary
By artwork¶
| Errata | (Any,) | (Name,) | (Name, Type) | (Type,) |
|---|---|---|---|---|
| Artwork | ||||
| Loading... (need help?) |
TCG & OCG status¶
TGC status¶
Total number of TCG status: 6
| Name | Password | Card type | Property | Archseries | Effect type | OCG status | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TCG status | ||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Card type | |||||
| Loading... (need help?) |
By monster type¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Monster type | |||||
| Loading... (need help?) |
By archseries¶
| TCG status | Forbidden | Illegal | Limited | Semi-Limited | Unlimited | All |
|---|---|---|---|---|---|---|
| Archseries | ||||||
| Loading... (need help?) |
OCG status¶
Total number of OCG status: 6
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OCG status | ||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Card type | |||||
| Loading... (need help?) |
By monster type¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Monster type | |||||
| Loading... (need help?) |
By archseries¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited | All |
|---|---|---|---|---|---|---|
| Archseries | ||||||
| Loading... (need help?) |
TCG vs. OCG status¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited | Unlimited | nan |
|---|---|---|---|---|---|---|---|
| OCG status | |||||||
| Loading... (need help?) |
Extras¶
Multiple secondary types¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Not yet released¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Counters and Tokens¶
| Name | Card type | Archseries | Attribute | Primary type | Monster type | Effect type | DEF | ATK | Level/Rank | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Page name differs from card name¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Epilogue¶
Execution completed 24/12/2023 20:12 UTC
HTML export¶
Notebook saved to disk
--------------------------------------------------------------------------- KeyError Traceback (most recent call last) File /opt/conda/lib/python3.11/site-packages/pandas/core/indexes/base.py:3790, in Index.get_loc(self, key) 3789 try: -> 3790 return self._engine.get_loc(casted_key) 3791 except KeyError as err: File index.pyx:152, in pandas._libs.index.IndexEngine.get_loc() File index.pyx:181, in pandas._libs.index.IndexEngine.get_loc() File pandas/_libs/hashtable_class_helper.pxi:7080, in pandas._libs.hashtable.PyObjectHashTable.get_item() File pandas/_libs/hashtable_class_helper.pxi:7088, in pandas._libs.hashtable.PyObjectHashTable.get_item() KeyError: 'card type' The above exception was the direct cause of the following exception: KeyError Traceback (most recent call last) Cell In[73], line 1 ----> 1 full_df[full_df["card type"].isna()] File /opt/conda/lib/python3.11/site-packages/pandas/core/frame.py:3893, in DataFrame.__getitem__(self, key) 3891 if self.columns.nlevels > 1: 3892 return self._getitem_multilevel(key) -> 3893 indexer = self.columns.get_loc(key) 3894 if is_integer(indexer): 3895 indexer = [indexer] File /opt/conda/lib/python3.11/site-packages/pandas/core/indexes/base.py:3797, in Index.get_loc(self, key) 3792 if isinstance(casted_key, slice) or ( 3793 isinstance(casted_key, abc.Iterable) 3794 and any(isinstance(x, slice) for x in casted_key) 3795 ): 3796 raise InvalidIndexError(key) -> 3797 raise KeyError(key) from err 3798 except TypeError: 3799 # If we have a listlike key, _check_indexing_error will raise 3800 # InvalidIndexError. Otherwise we fall through and re-raise 3801 # the TypeError. 3802 self._check_indexing_error(key) KeyError: 'card type'